on 05-18-2016 3:53 PM
Hi All,
Can PI pick up one file and output multi files based on key field value? That is when the key field value changes, create a new file?
Thanks,
Charles
Hello Charles,
Is it like below
Key
1--------------------------------------------One File
1
2---------------------------------------------Second File
3----------------------------------------------Third file
Multimapping should help in your case.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you need to use message split in mapping to create multiple messages, and in turn multiple files for every value change
for example,
message type for source and target
use SplitByValue on each value change as below
when execute this mapping the result will be as below,
your message type could be different based on your exact requirements, but as Raghuraman has already mentioned , with group and split by value you should be able to achieve this.
Hi Nav,
I still keep getting error " Cannot create target element /ns0:Messages/ns0:Message1/ns1:MT_TEST". I tested in MM and OM. It works there. But when I use my source file, I keep getting that error.
Do you have any idea what is wrong with it? I have attached my mapping, FCC setting and source file. I would like to output 3 files based on it.
Thanks a lot!
Charles
Hi Charles,
can you check you are using the correct operation mapping in configuration,
your error says cannot create 'MT_TEST', whereas the mapping that you tested does not have this tag.
please check the configuration again,
provide the payload that you are getting after the content conversion.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.