Need help in excel column split

Help Activities
, ,
1

Hi Everyone,

I’m facing an issue in excel split, I have a column it is having multiple rows of data i want to split it into multiple columns.
I’m attaching my excel. it have sample data and output also.

If Temp value is empty i need to write it as Ownset

Sample file split.xlsx (16.7 KB)

Can anyone guide me which formula i need to use there to get that kind of output

1 Like
2

Hey @Learner007

Use the for-each row to iterate rows & you can do the below inside loop !

You can please pass the below into De-serialize Json activity & set the TypeArgument to DataTable

"{" + str_RowData.Replace(Environment.Newline,",") + "}"

Thanks
#nK

3

Hi @Nithinkrishna

I’m getting some error I’m doing something wrong here can you correct me.

IMG_20220724_225733
IMG_20220724_2257331920×1139 178 KB

IMG_20220724_225712
IMG_20220724_2257124624×3472 2.91 MB

4

when surrounding with { } we will not get a valid JSON as the property names / String values also need to be quoted

We can use regex e.g.

grafik
grafik865×276 35.3 KB

and referring to the groups:
grafik
grafik754×773 29.5 KB

(,|\b)(.*?)(:)(.*?)(,|$)

As mentioned above we can also do it line by line and will split it before with vbLF

1 Like
5

Thanks @ppr by using this regex code, i made a flow with few more activities. It is working.

6

Hey @Learner007

In the output property of the De-serialize activity use a data table variable please.

Thanks
#nK

7

Sure @Nithinkrishna i will try that

1 Like
8

Cool buddy @Learner007 :+1:

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.