+14Hey,
Is there any way to do Text to Columns in Pigment?
Currently trying to resolve this dynamically:
Dimension List: Player Details
Dimension List: Sports
Need to create a boolean metric with dimensions: “Player Details” and “Sports” ; which can check if a sport has been played by a specific player or not i.e if it exists in “Participated Sports” or not
+14
+14Update:
I have tried this formula and it’s working as expected:
CONTAINS(Sports.Name,'Player Details'.Sport[BY: -> Sports[FILTER: Sports.Name."E"]])
OR
CONTAINS(Sports.Name,'Player Details'.Sport[BY: -> Sports[FILTER: Sports.Name."PQR"]])
OR
CONTAINS(Sports.Name,'Player Details'.Sport[BY: -> Sports[FILTER: Sports.Name."CD"]])
OR
CONTAINS(Sports.Name,'Player Details'.Sport[BY: -> Sports[FILTER: Sports.Name."B"]])
OR
CONTAINS(Sports.Name,'Player Details'.Sport[BY: -> Sports[FILTER: Sports.Name."A"]])The only issue is: if a new sport is added in the Dimension List of “Sports”, this formula needs to be updated
+14This has been resolved using:
CONTAINS(Sports.Name,'Player Details'.Sport[BY: -> Sports])
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.