Forum Discussion
Helper IReturn value based on column contents in another table
Community ChampionHello ksteever
i just need to get understand the logic.
in the original table, i can have many rows with the same parent , correct ?
this means
parent data software
p1 true true
p1 false false
p1 true false
nowin the new table, we have unique parent values :
parent
p1
when you are creating the new calculated column, p1 is related to 3 rows, with different values,
so the result will depend on which row ?
ksteeverCorrect. The software column and data column will never both be true at the same time in the original table. Here's an example table if you wanna play with a small chunk of data since I cant attach xls/csv here.
Parent key Softwaredev DataEng ELS-5 False False ELS-14 False False ELS-23 False False ELS-1 False False ELS-54 False False ELS-13 False False ELS-21 False False ELS-10 False False ELS-7 False True ELS-12 False False ELS-31 False False DRS-126 False False DRS-125 False False DRS-123 False False DRS-50 False False DRS-117 False False DRS-3 False False ELS-5 False False ELS-14 False False ELS-23 False False ELS-1 False False ELS-54 False False ELS-13 False False ELS-21 False False ELS-10 False False ELS-7 False False ELS-12 False False ELS-31 False False DRS-126 False False DRS-125 False True DRS-123 False False DRS-50 False True DRS-117 False False DRS-3 False False ELS-5 False False ELS-14 False False ELS-23 False False ELS-1 False False ELS-54 False False ELS-13 False False ELS-21 False True ELS-10 False False ELS-7 False False ELS-12 False False ELS-31 False False DRS-126 False False DRS-125 False True DRS-123 False False DRS-50 False False DRS-117 False True DRS-3 False False ELS-5 False True ELS-14 True True ELS-23 False False ELS-1 False False ELS-54 False False ELS-13 False False ELS-21 False False ELS-10 False False ELS-7 True False ELS-12 False False ELS-31 False False DRS-126 False False DRS-125 False False DRS-123 False False DRS-50 True False DRS-117 False False DRS-3 False False DRS-126 False False DRS-125 False False DRS-123 False False DRS-50 True False DRS-117 False False DRS-3 False False DRS-117 False True Here's a list of the unique values:
Parent key unique ELS-5 ELS-14 ELS-23 ELS-1 ELS-54 ELS-13 ELS-21 ELS-10 ELS-7 ELS-12 ELS-31 DRS-126 DRS-125 DRS-123 DRS-50 DRS-117 DRS-3 - ksteever
Daniel29195 any insights?