Conditional Expression

[noman212]

Dear Community,

i made concatenated Column on my load script

'01' & TOWN & LOCALITYCODE & SLOCALITYCODE & POP & DISTRIBUTORCODE as DISTRIBUTORCODE_SHOP

in the field DISTRIBUTORCODE i have multiple shop name against same TOWN & LOCALITYCODE & SLOCALITYCODE & POP

but from presentation layer i want to make a conditional variable that work on base of selection if i select in self service BI from field on he basis of TOWN,LOCALITYCODE ,POP  it shows unique value on the base of same TOWN,LOCALITYCODE ,POP but if i select DISTRIBUTORCODE its shows all shops against this DISTRIBUTORCODE.

Note :  DISTRIBUTORCODE have multiple shops against TOWN,LOCALITYCODE ,POP.

Need your help on this above scenario.

Regards

Noman khan

[Kushal_Chawda]

Can you show some sample data and expected output for that?

[sunny_talwar]

Not sure I completely follow your requirement. Would you be able to share a sample with the expected output?

[avinashelite]

Agreed with Sunny and Kushal

please share the sample data and required output format otherwise it will be hard to guess the requirement

[noman212]

=if(SubStringCount(Concat(Distinct DISTRIBUTORCODE), DISTRIBUTORCODE)>0, SHOPCODE, left(SHOPCODE,len(SHOPCODE)-right(SHOPCODE,4)))

please help me to correct this expression

if i select distributor code it display complete shop code like

01T000021350080300112

else

len - 4

01T00002135008030

[noman212]

Please find the attached sample file

[tamilarasu]

Like attached.?