Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Data from 2Files
File1
Sales ID | Sales Amount
1| 100
2| 200
File2
Sales ID | Budget Amount
1| 170
2| 290
I Want to pick the Max of (Sales amount and Budget amount) and put it in a new field . need to perform this on the Load script..
For Ex: Sales ID | Sales Amount| Budget Amount|MaxCheck
1| 100|170|170
Something like this?
Temp:
NOCONCATENATE
LOAD * // Data from File1
INLINE [
Sales ID, Sales Amount
1, 100
2, 200
];
JOIN (Temp)
LOAD * // Data from File2
INLINE [
Sales ID, Budget Amount
1, 170
2, 290
];
Final:
NOCONCATENATE
LOAD *,
RangeMax([Sales Amount], [Budget Amount]) AS MaxCheck
RESIDENT Temp
;
DROP TABLE Temp;
When Iam running this to the whole data set i dont get the correct Rangemax results.. But when i using it in expression it works
For Ex: when running in script
Sales ID | Sales Amount| Budget Amount|MaxCheck
1| 100,987|187,654|190,356
when using in expression it works correct
Sales ID | Sales Amount| Budget Amount|MaxCheck
1| 100,987|187,654|187,654
But as i need this in load script.. as the file too huge and i would like store it in specific folder