Input Tool not Showing Data

[SamYX]

I'm trying to input a Named Range called "VL_List" ( Pic 1) but the output of the Input Tool shows all different values ( Pic 2) with 3 columns where as the Named Range is only one column  

But if i remove the adjacent values ( Pic 3) the Input Tool gives correct values ( Pic 4) 

Please help to understand why the Tool behaves like that

[ShankerV]

Hi @SamYX 

I believe you are using the .xlsx format to import.

Please make use of the Range which will help you to import only the desired columns.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @SamYX 

Please find an use case to explain your scenario.

Input file:

Input tool:

Please see the values loaded in alteryx as per your expectation.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[rachelgomez]

Simply follow these steps:
Go to Settings, then System.
Select Apps & Features, and then click Manage optional features.
Click Add a feature, find Hindi typing, and then install.

Regards,

Rachel Gomez

[SamYX]

Hi @ShankerV ,

Thanks for the solution but i just want to know why the Named Range is behaving differently with data adjacent to the column and without 

I can use the Rage feature but Named Range is more easy to use every time if the range changes   

[SamYX]

Hi @rachelgomez ,

Thanks for the reply but What is "Hindi Typing"..not sure what you mean by that

[ShankerV]

Hi @SamYX 

Please be informed that, the table is reading the file correctly.

Kindly do check my attached file and confirm.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @SamYX 

I see when the Table Range is also changed, the Alteryx is reading the Data's are reading correctly.

Please check my use case once. That will help.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[SamYX]

yes..that's the usual thing..but in my case if don't remove the data from the adjacent columns Input Tool is unable to read the data..not sure why ...i had to remove all the data and process..

[ShankerV]

Hi @SamYX 

Can you please attach your workflow and the excel sheet, will check on the settings and confirm.

It will be the issue in the settings.

Many thanks

Shanker V