Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hope this helps!!
Thanks
Could you please share the automation and app you have configured to investigate this further?
Thanks
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.
Hope this helps!!
Thanks
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