I have a set of table that looks like this
Item | Amount | Quantity |
RM | RM | |
Laptop | 1000 | 150 |
Table | 500 | 150 |
Chair | 1200 | 150 |
when i import it from XLSB into alteryx, it turns into this
Item | Quantity | |
RM | ||
Laptop | 1000 | 150 |
Table | 500 | 150 |
Chair | 1200 | 150 |
The "Amount RM" went missing, the Column "Item" and "Quantity" is V_string, whereas "Amount RM" turns into double, hence removing the table title.
I am using the macro from this link :Batch Macro to import multiple file having differe... - Alteryx Community
Hi @terrellchong - If you could provide your file and workflow that would help.