I'm trying to concatenate two fields in my load statement:
BIN:
LOADBin,
[Last Four],
concat( Bin&'*****'&[Last Four]) asCardNumber
FROM
[Concat Test.xlsx]
(ooxml, embeddedlabels, tableisSheet1);
My goal's to create a field 'Card Number' by combining 'Bin' and 'Last Four', however, I keep getting sytax errors when I try and load it. I've read a few posts on this and can't see the issue with my script. Any suggestions would be more than welcome.
returns the aggregated string concatenation of all values of expression iterated over a number of records as defined by a group by clause. Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first. If the word distinct occurs before the expression, all duplicates will be disregarded.
So I think the syntax you used will not return a list of values to iterate over, that's why it causes an error.
Concat is used to e.g. get a comma separated string of values of a dimension like:
When I edit the script according to your suggestion, I get the same error. Would you mind showing me how you'd do it with the attahced excel as an example?
