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