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.
