SPLIT DATA USING A SPECIFIC COLUMN AND ADD COLUMN NAMES

[Shahas]

Hi All,

I have a situation where in I have to group data by country and after each country is over, a separate header has to be given when a new country name begins.

for eg : 

ID	NAME	COUNTRY
12	AB	AUS
35	CD	IND
64	LE	AUS
78	OI	IND
95	FG	SUI
21	LF	SUI
65	PO	UK
17	LQ	UK

This data has to look like : 

ID	NAME	COUNTRY
12	AB	AUS
64	LE	AUS
ID	NAME	COUNTRY
35	CD	IND
78	OI	IND
ID	NAME	COUNTRY
95	FG	SUI
21	LF	SUI
ID	NAME	COUNTRY
65	PO	UK
17	LQ	UK

Hope its clear.

Thanks in advance

[ShankerV]

Hi @Shahas 

One way of doing this.

Many thanks

Shanker V

[Shahas]

Heyy @ShankerV 

Thank u for the response

Could u please upload the flow?

[binuacs]

@Shahas One way of doing with the batch macro

[ShankerV]

Hi @Shahas 

Step 1: Input

Step 2: 

Step 3:

Step 4:

Step 5:

Step 6:

RowCount <= [Tile_SequenceNum]

[ShankerV]

Hi @Shahas 

Step 7: 

IF [RowCount]=2
THEN [Field1]
ELSE [Source_Field1]
ENDIF

Step 8:

Step 9:

Step 10:

Many thanks

Shanker V

[Shahas]

@ShankerV thanks for the effort put in to post everything. 

A small doubt.. At step 7, formula's are being applied to source field. In the example I provided there are only 3 source fields. But in my actual data, there a lot more. So do I have to apply formula to every columns?

Thanks & Regards

Shahas Ahamed

[Shahas]

@binuacs  Thank u for the response.

But when  run the flow, I'm getting a lot of duplicates.

In my data, there are 39 countries in total. In the macro section, we are giving 1 country name right in filter ? and what will we do for the false part?

Thanks & Regards

Shahas Ahamed

[ShankerV]

Hi @Shahas 

Yes, as per the sample provided I have applied the formula to all 3 fields.

If in the original input, if you have more columns, then the formula should be applied to all the columns.

Many thanks

Shanker V

[ArtApa · Accepted solution]

Hi @Shahas - Here is a possible solution: