Hi Team,
Attaching you the input file.
PO_creation_WF.xlsx (13.4 KB)
in the input file 12110158704 this Record ID next to this 5 rows are empty i need to enter all the empty rows with same Record ID
Same for this Record ID also 12034748666 next rows are empty it should fill the Record ID value in the first Column. Reference Check the file attached below.
PO_creation_WF.xlsx (13.5 KB)
Below is the output file
Thanks
Likitha
ppr
(Peter Preuss)
September 11, 2023, 8:25am
2
You can fillup the empty rows by using below pattern. Replace yellow marked = by your column index or column name
Hi
I need to add all the rows not first column value where ever is empty i has to enter the all the data
Example
Input file:
PO_creation_WF.xlsx (13.4 KB)
Output file:
The data already filled in the empty rows should not get changed the rows which are empty those rows has to fill with the data
PO_creation_WF.xlsx (14.3 KB)
Thanks
Likitha
Please compare input and output file
ppr
(Peter Preuss)
September 11, 2023, 6:03pm
4
to extend the logic to other column fillings is possible and can be done in the same way as showcased within the starter help
Their are 15 to 20 rows same logic i need to add
is their any other way
ppr
(Peter Preuss)
September 11, 2023, 6:41pm
6
you can modify the check and using the previous’ row itemArray when empty line / empty column value is detected as an alternate approach
ppr
(Peter Preuss)
September 11, 2023, 7:48pm
8
tmpItemArray | Object Array
Condition - check for complete empty rows :
row.ItemArray.All(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.ToString.Trim))
OR
Condition - check for particular column set:
arrColSet String Array = new String(){“Col1”,“ColX”,“ColY”…}
arrColSet.All(Function (x) isNothing(row(x)) OrElse String.IsNullOrEmpty(row(x).ToString.Trim))
it is not working it is not going to then part.
ppr
(Peter Preuss)
September 12, 2023, 7:35am
10
vinjam_likitha:
it is not working i
It is better to tell us what was done in detail and what exactly is not working
Ist Logic i tried
row.ItemArray.All(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.ToString.Trim))
Input and Output are same nothing is changed
arrColSet String Array = new String(){“Col1”,“ColX”,“ColY”…}
This is didnt understand so i didnt tried
Can you please help me to get the solution
Thanks
likitha
ppr
(Peter Preuss)
September 12, 2023, 8:13am
12
then better to get it understood
When in detail comparing your input (above yellow line) and expected output (below yelow line)
we can detect:
1 or more columns can be used to detect, when a filling up is needed
not all columns are to fill up (blue boxes)
a filling up is detected, which is not covered from the description (red box)
From all above given help we introduced a few main building blocks which can be adapted from your side to finalize the case
arrFillUpColSet of these columns thats will be used for the filling up
fillup need detection (for the if condition)
fillup on empty rows OR grabbing the new fill up values dynamically by using the arrFillUpColSet
Thanks for explaining
What logic we can write for this