Hi All, How to categorize the data based on word, I want to make my data as below format could you. Please suggest how to format data as shown below. FieldDataExpectedOutputFieldDataTempId Announcement Sequence Code: AB22 Announcement Sequence Code: AB22 0 Announcement TypeTest Announcement TypeTest0 Announcement TypeEx-DateEntry DatePayment DateRecord DateSubject to ApprovalDeclaration DateClose of Business/Dividend Declaration CodeEx-DateTest Ex-DateTest0 Announcement Sequence Code: AB22TestTestTestTestTestTest Entry DateTest Entry DateTest0 Revision to Announcement: AB22Test1Test1Test1Test1Test1Test1Test1Test1Payment DateTest Payment DateTest0 Announcement Sequence Code: AC22Test2Test2Test2Test2Test2Test2Test2 Record DateTest Record DateTest0 Announcement Sequence Code: AD22Test3Test3Test3Test3Test3Test3Test3Test3Subject to ApprovalTest Subject to ApprovalTest0 Revision to Announcement: AB22 Revision to Announcement: AB22 1 Announcement TypeTest Announcement TypeTest11 Ex-DateTest Ex-DateTest11 Entry DateTest Entry DateTest11 Payment DateTest Payment DateTest11 Record DateTest Record DateTest11 Declaration DateTest Declaration DateTest11 Close of Business/Dividend Declaration CodeTest Close of Business/Dividend Declaration CodeTest11 Subject to ApprovalTest Subject to ApprovalTest11 Announcement Sequence Code: AC22 Announcement Sequence Code: AC22 2 Announcement TypeTest Announcement TypeTest22 Ex-DateTest Ex-DateTest22 Entry DateTest Entry DateTest22 Payment DateTest Payment DateTest22 Record DateTest Record DateTest22 Declaration DateTest Declaration DateTest22 Subject to ApprovalTest Subject to ApprovalTest22 Announcement Sequence Code: AD22 Announcement Sequence Code: AD22 3 Announcement TypeTest Announcement TypeTest33 Ex-DateTest Ex-DateTest33 Entry DateTest Entry DateTest33 Payment DateTest Payment DateTest33 Record DateTest Record DateTest33 Declaration DateTest Declaration DateTest33 Close of Business/Dividend Declaration CodeTest Close of Business/Dividend Declaration CodeTest33 Subject to ApprovalTest Subject to ApprovalTest33 Thanks & Regards, Niranjan

Categeraing data based on word or name

Hi All,

How to categorize the data based on word, I want to make my data as below format could you. Please suggest how to format data as shown below.

Field

Data

ExpectedOutput

Field

Data

TempId

Announcement Sequence Code: AB22

Announcement Type

Test

Announcement Type

Test

Announcement Type

Ex-Date

Entry Date

Payment Date

Record Date

Subject to Approval

Declaration Date

Close of Business/Dividend Declaration Code

Ex-Date

Test

Ex-Date

Test

Announcement Sequence Code: AB22

Test

Entry Date

Test

Entry Date

Test

Revision to Announcement: AB22

Test1

Payment Date

Test

Payment Date

Test

Announcement Sequence Code: AC22

Test2

Record Date

Test

Record Date

Test

Announcement Sequence Code: AD22

Test3

Subject to Approval

Test

Subject to Approval

Test

Revision to Announcement: AB22

Announcement Type

Test

Announcement Type

Test1

Ex-Date

Test

Ex-Date

Test1

Entry Date

Test

Entry Date

Test1

Payment Date

Test

Payment Date

Test1

Record Date

Test

Record Date

Test1

Declaration Date

Test

Declaration Date

Test1

Close of Business/Dividend Declaration Code

Test

Close of Business/Dividend Declaration Code

Test1

Subject to Approval

Test

Subject to Approval

Test1

Announcement Sequence Code: AC22

Announcement Type

Test

Announcement Type

Test2

Ex-Date

Test

Ex-Date

Test2

Entry Date

Test

Entry Date

Test2

Payment Date

Test

Payment Date

Test2

Record Date

Test

Record Date

Test2

Declaration Date

Test

Declaration Date

Test2

Subject to Approval

Test

Subject to Approval

Test2

Announcement Sequence Code: AD22

Announcement Type

Test

Announcement Type

Test3

Ex-Date

Test

Ex-Date

Test3

Entry Date

Test

Entry Date

Test3

Payment Date

Test

Payment Date

Test3

Record Date

Test

Record Date

Test3

Declaration Date

Test

Declaration Date

Test3

Close of Business/Dividend Declaration Code

Test

Close of Business/Dividend Declaration Code

Test3

Subject to Approval

Test

Subject to Approval

Test3

Thanks & Regards,

Niranjan

Best Practices

Dynamic Processing

Data Investigation

Documentation

Accepted answers

ShankerV

@NiranjanK1

Please find the solution to bring all the datas in to workflow.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

All datas to the workflow Categeraing data based on word or name.yxmd

All comments

ShankerV

@NiranjanK1

Happy new year!!!!

Please find the below expected solution.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Categeraing data based on word or name.yxmd

NiranjanK1

@ShankerV Thanks for your reply in actaul data i have some data gaps also in that case how can i categeraze data. please find the below actual data for your reference. Please suggest

Field	Data
Revision to Announcement: AA22
Announcement Type	change announcement
Ex-Date	15 Mar 2022
Entry Date	12 Aug 2022
Payment Date	31 Mar 2022
Record Date	16 Mar 2022
Declaration Date	10 Feb 2022
Due-Bill-On Date
Due-Bill-Off Date
UIT Preliminary/Final Announcement	Does not apply
Close of Business/Dividend Declaration Code	Does not apply
Subject to Approval	Does not apply
Revision to Announcement: AC22
Announcement Type	change announcement
Ex-Date	13 Sep 2022
Entry Date	12 Aug 2022
Payment Date	29 Sep 2022
Record Date	14 Sep 2022
Declaration Date	11 Aug 2022
Due-Bill-On Date
Due-Bill-Off Date
UIT Preliminary/Final Announcement	Does not apply
Close of Business/Dividend Declaration Code	Does not apply
Subject to Approval	Does not apply
Announcement Sequence Code: AD22
Announcement Type	change announcement
Ex-Date	29 Nov 2022
Entry Date	10 Nov 2022
Payment Date	30 Dec 2022
Record Date	30 Nov 2022
Declaration Date	10 Nov 2022
Due-Bill-On Date
Due-Bill-Off Date
UIT Preliminary/Final Announcement	Does not apply
Close of Business/Dividend Declaration Code	Does not apply
Subject to Approval	Does not apply
Announcement Sequence Code: AE22
Announcement Type	change announcement
Ex-Date	12 Dec 2022
Entry Date	24 Nov 2022
Payment Date	9 Dec 2022
Record Date	2 Dec 2022
Declaration Date	22 Nov 2022
Due-Bill-On Date	2 Dec 2022
Due-Bill-Off Date	13 Dec 2022
UIT Preliminary/Final Announcement	Does not apply
Close of Business/Dividend Declaration Code	Does not apply
Subject to Approval	Does not apply
Supplemental Information for	change announcement
Equivalent Cash Rate	0
Ratio of No. Shares Received for Each Share Held for 1st Issue	0.25
CUSIP of 1st Issue Distributed
Additional Distribution Indicator
ADR/ORD Basis of Issuance

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703