Solved: Re: find row in excel data table no match - Qlik Community

Greg_collaboration · ‎2023-06-05

There is a good video by Qlik on "Creating a basic write back solution with Qlik Cloud"

But I can you show the same for an Excel file table saved in OneDrive?

To add a row is not an issue but...

I have an issue with the autiomaton "find row in excel find row in excel data table" as it never matches.

I habe a simple table and when i do the find row in excel data table it loops trhough and when the values are matching

The Variable "Inputrow001" is a list with one enetry = 3 for matchup

The datatable I use:

Casenumber	Column2	Column3
1	11	111
2	12	112
3	13	113
4	14	114
5	15	115
6	16	116
7	17	117
8	18	118
9	19	119
10	20	120
11	21	121
12	22	122
13	23	123
14	24	124

Automation:

I search for the 3 in the Column Casenumber from get streight table data.

But when is sholud match it still gives teh result -1 and not the number of the row

please can you help here?

Can qlik make a step by step video.

The step after will be an update rowl in Excel table.

AfeefaTk · ‎2023-06-05

Hi @Greg_collaboration

I guess you have provided incorrect values to the input fields of the "Find Row In Excel Worksheet Table" block.

The input value for "Column Index For Search" parameter should be the index of the column on which you have to search for the values provided in the "Search Value" parameter.

So if Casenumber is the first column in your Excel table then the Column Index For Search = 0.

Then add a condition block to check if the "Find Row In Excel Worksheet Table" block response is not empty or the index value from the "Find Row In Excel Worksheet Table" block response is not equal to -1. If the condition evaluates to true, place the "Update Row In Table" block.

Hope this helps!!
Thanks

View solution in original post

AfeefaTk · ‎2023-06-05

Hi @Greg_collaboration

Could you please share the automation and app you have configured to investigate this further?

Thanks

AfeefaTk · ‎2023-06-05

Hi @Greg_collaboration

I guess you have provided incorrect values to the input fields of the "Find Row In Excel Worksheet Table" block.

The input value for "Column Index For Search" parameter should be the index of the column on which you have to search for the values provided in the "Search Value" parameter.

So if Casenumber is the first column in your Excel table then the Column Index For Search = 0.

Then add a condition block to check if the "Find Row In Excel Worksheet Table" block response is not empty or the index value from the "Find Row In Excel Worksheet Table" block response is not equal to -1. If the condition evaluates to true, place the "Update Row In Table" block.

Hope this helps!!
Thanks

AfeefaTk · ‎2023-06-08

Hi @Greg_collaboration

Did it work?

If yes, do you mind sharing the automation and app configured which could help others trying to write back to the Excel file?

Thanks

find row in excel data table no match

Microsoft Excel

Microsoft OneDrive

Then add a condition block to check if the "Find Row In Excel Worksheet Table" block response is not empty or the index value from the "Find Row In Excel Worksheet Table" block response is not equal to -1. If the condition evaluates to true, place the "Update Row In Table" block.

Then add a condition block to check if the "Find Row In Excel Worksheet Table" block response is not empty or the index value from the "Find Row In Excel Worksheet Table" block response is not equal to -1. If the condition evaluates to true, place the "Update Row In Table" block.