Error on Random sampling limited to % of the segment

Avatar

Avatar
Validate 1
Level 1
andreeam-nc
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
andreeam-nc
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
andreeam-nc
Level 1

10-02-2018

Hi!

I am trying to do a Random sampling limited to 50 % of the segment. On random sampling from entire incoming target, I get no error (considering Split activity set up would not differ too much) but this is not what I need

For instance: my target population has 75 recipients; I filter by gender Code of targeting dimension equal to 'F'; then select Random sampling, limited to 50 % of the segment. On running the WF, the Split activity fails. This is what I get in the journal:

02/10/2018 11:26:15 PM       extract Only 0 record(s) have been selected while 9 were requested for result 'Female' of extraction 'Split'.

02/10/2018 11:26:15 PM       extract SQL statement 'INSERT INTO wkf63278912_53_1(iId,sGENDER,sSegmentCode) SELECT   W0.iId FROM wkf63278912_52_1 W0 JOIN NmsRecipient R1 ON (R1.iRecipientId = W0.iId) WHERE (R1.sGENDER = E'F') ORDER BY random() LIMIT 9' could not be executed.

02/10/2018 11:26:15 PM       extract PostgreSQL error: ERROR:  INSERT has more target columns than expressions LINE 1: INSERT INTO wkf63278912_53_1(iId,sGENDER,sSegmentCode) SELEC... ^

Tried in 2-3 environments with different data - same thing every time. Can anyone help please?

thank you,

Andreea

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
shrawans3153003
Employee

10-02-2018

Hi Andreea,
Have you selected gender and segment as output columns while querying from Recipients.

Could you please remove that and run the workflow again.

1415617_pastedImage_0.png

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
andreeam-nc
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
andreeam-nc
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
andreeam-nc
Level 1

11-02-2018

Hi, this helped me solve it, thank you! I had actually assigned segment codes in the split activity; once removed those, the split activity ran and segment population count - as expected.

But now, to complicate the scenario a bit -  what if before the split I'm using an enrichment ? (I'm loading some data and the query will be made by one of the fields loaded; also, one of the fields previously loaded will be used in the delivery. Do you see any solution for this?