Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need to create a new field (Distributor) based on two existing fields ( Disti_Name , Disti_Corp_ID) with the condition shown in table below.
Is there any way to do this other than hard code?
You could do it in two ways:
1: create during the table load statement a concatenation of the two fields, something like
load * Inline
Disti_Name & '|' & Disti_Corp_ID as Key_LoadStatement
drop table x;
Or create a table with the expression:
"=Disti_Name & Disti_Corp_ID"
Attached is a QVW with both options.
Thanks Felip. Will test on this and update here.