We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.

Alteryx Designer Desktop Discussions

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

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