Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I've loaded a temporary detail table then perfromed a left joined to move some header data into the deatil table.
I now need to do a NOCONCATENATE LOAD . Within the NONCOCATENATE LOAD I perform some calculations using the data moved to the detail table.
I now want to perform additional logic using the calculations in a preceding load.
My question is can I do a preceding load with a NOCONCATENATE LOAD as in the attached example?
I'm not able to connect to a server to test it. If it isn't proper syntax, I'm going to need to code it differently for tomorrow.
Thanks,
Rich
Hello Rich,
Is is possible to do the calculations in the same load without needing a preceding load? If you need to create a new field, you can do that in the table you are loading.
Anyway, something like the following should work
Data:LOAD * INLINE [ID, Code1, A2, B3, C]; OtherData:NOCONCATENATE LOAD ID AS ID2, // Prefix here Code AS Code2, Repeat(Code, 5) AS Name;LOAD *RESIDENT Data;
Hope that helps.
Hello Rich,
Is is possible to do the calculations in the same load without needing a preceding load? If you need to create a new field, you can do that in the table you are loading.
Anyway, something like the following should work
Data:LOAD * INLINE [ID, Code1, A2, B3, C]; OtherData:NOCONCATENATE LOAD ID AS ID2, // Prefix here Code AS Code2, Repeat(Code, 5) AS Name;LOAD *RESIDENT Data;
Hope that helps.
Thanks Miguel,
I see, The NOCONCATENATE LOAD statement is the preceding load.
Best Regards,
Rich
PS: Yes, it is possible to do it in the same load but I would need to repeat detail conditions that can be avoided by the preceding load.