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 : IDNAMECOUNTRY12ABAUS35CDIND64LEAUS78OIIND95FGSUI21LFSUI65POUK17LQUK This data has to look like : IDNAMECOUNTRY12ABAUS64LEAUSIDNAMECOUNTRY35CDIND78OIINDIDNAMECOUNTRY95FGSUI21LFSUIIDNAMECOUNTRY65POUK17LQUK Hope its clear. Thanks in advance

SPLIT DATA USING A SPECIFIC COLUMN AND ADD COLUMN NAMES

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

Workflow

Optimization

Data Investigation

Accepted answers

ArtApa

Hi @Shahas - Here is a possible solution:

AddColumnNameAA.yxmd

All comments

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?

binu_acs

@Shahas One way of doing with the batch macro

Column_210423.yxzp

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

@binu_acs 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?