Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Disable input tool auto data field

terrellchong
8 - Asteroid

I have a set of table that looks like this

 

ItemAmountQuantity
 RMRM
   
Laptop1000150
Table500150
Chair1200150

 

when i import it from XLSB into alteryx, it turns into this

 

Item Quantity
  RM
   
Laptop1000150
Table500150
Chair1200150

 

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

1 REPLY 1
ArtApa
Alteryx
Alteryx

Hi @terrellchong - If you could provide your file and workflow that would help.

Labels
Top Solution Authors