Input Tool not Showing Data

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

Workflow

Accepted answers

All comments

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

Input Tool not Showing Data.yxmd

Test for SamYX.xlsx

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703