Allan Bøgh Madsen
Activity overview
Latest activity by Allan Bøgh Madsen-
Allan Bøgh Madsen commented, Hi, Just wanted to share the syntax if you need to set METADATA for more than one column. The syntax is as below. SELECT * FROM [C:\test.csv] (METADATA: [Column1](type:string, ordinal:0), [Column2...
-
Allan Bøgh Madsen commented, Hi Ole, I suspected this was the case :-) Thanks for confirming. I will works with several KPI-object to get the desired result.BR / Allan
-
Allan Bøgh Madsen commented, Hi Ole, I have made a KPI object containing 4 values but it is only the first 3 that works. Is the KPI object limited to 3 values?
-
Allan Bøgh Madsen commented, Hi again,I have now had time to test it, and it works with select * from... and using ordinal 1 instead of 2. However I also have to make a product id that is a combination of 3 columns ( Varenumme...
-
Allan Bøgh Madsen commented, The file is autogenerated by our ERP-system, so I'm not able to change ø to o without doing it manually every time :)
-
Allan Bøgh Madsen commented, Hi again, Yes, I can share the file. However it's not possible to attach it here. I uploaded it to Mega som it can be downloaded here https://mega.nz/file/jXpCybBY#RlgxUUHJTrpeXRRQ1U0TVGsgn0V5OXKg...
-
Allan Bøgh Madsen commented, Hi Allan, Thank you for your answer and suggestion. I just tested it out and unfortunately there no difference - the zero is still removed from the column "Lagersted" Datasource is set up like this...
-
Allan Bøgh Madsen commented, Hi Ole, Thank you for the guide. Is it possible to define different datatypes for columns? I have a csv-file where some columns is strings and other numeric. One of the string columns has a value '...