This content has been marked as final. Show 4 replies
Do anyone had practice how to save second part (number) of dual values in the script after several data transformation?
For example, in first step i define dual values using excel source:
if(Name='D-44', dual('D-44',4))))) as Name
(ooxml, embedded labels, table is Sheet1);
First result is ok:
But after some data transformation dual sorting is missing in the result:
if(Name='D-44', 'Last' & Name,
subfield(Name,'-',-1)) as Name
DROP Table Temp;
Any idea how to keep number dual values in this case?