source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be lik

source
file name xyz

a,0,a,a,a
b,b,b,0,b
c,c,c,0,c

target should be like this

xyz
a
b
c

how to implement this?

Question Posted / siva

4 Answers
7083 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b ..

Answer / dbloc

Based on the data structure, there are 3 rows present. The
clear indicator here is that the last character of each row
does not have a comma.

A sorter (as previously answered will not handle this using
it's DISTINCT option because each row is distinct. The
previous Normalizer answer just baffles me.

Simple answer: Connect to an expression and only connect
the first port of the record to the target.

a
b
c

Keep it simple.

Is This Answer Correct ?

9 Yes

0 No

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b ..

Answer / dilip ingole

don't specify delimiter while importing file and use similar function in informticw as

SELECT substr(REGEXP_REPLACE('a,0,a,a,a','[^[:alpha:]]',''),1,1) FROM DUAL;

Is This Answer Correct ?

0 Yes

1 No

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b ..

Answer / rajesh

use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows

Is This Answer Correct ?

0 Yes

3 No

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b ..

Answer / amedela chandra sekhar

By using sorter t/r select distinct option
it eliminate the duplicates.

Is This Answer Correct ?

0 Yes

8 No

Post New Answer