Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Replace (Concat(distinct KPI,''),',', ' * ')
Hi
Try like below
Load *, trim(SubField(KPI,',')) as KPI1 Inline
[
KPI
Sales, Customer
Sales, Source
](delimiter is '|');
Exp:
=Concat(distinct KPI1,'*')
Hi
Try like below
Load *, trim(SubField(KPI,',')) as KPI1 Inline
[
KPI
Sales, Customer
Sales, Source
](delimiter is '|');
Exp:
=Concat(distinct KPI1,'*')
Thanks Man!