on 09-24-2007 9:26 AM
Hello, I have a challenge.
I am want to syndicate a material classification (taxonomy table) and related attributes to a flat file. I want the result to look like this:
C 613316 VALVE_MANUAL_
D 613316 PRESSURE_RATING_CLASS_INLET_ Class 150
D 613316 MATERIAL_DESCRIPTION_BODY_ Duplex stainless steel
D 613316 OPERATOR_TYPE_ Manual
D 613316 CONNECTION_DESIGN_INLET_ RF
D 613316 VDS_REF_ L-SP-200
D 613316 NOMINAL_SIZE_INLET_ 1/2"
D 613316 VALVE_DATA_SHEET_ GT078
C 613437 VALVE_MANUAL_
D 613437 MATERIAL_DESCRIPTION_BODY_ Duplex stainless steel
D 613437 OPERATOR_TYPE_ Manual
D 613437 CONNECTION_DESIGN_INLET_ RF
D 613437 PRESSURE_RATING_CLASS_INLET_ Class 150
D 613437 NOMINAL_SIZE_INLET_ 3/4"
D 613437 VALVE_DATA_SHEET_ GT078
D 613437 VDS_REF_ L-SP-200
1st column is C for class or D for attribute
2nd column is material number (as you see one line per attribute).
3rd column is attribute name
4th column is attribute value.
Does anyone know a way to syndicate to a flat file like this?
Best regards
John-Kjell
problem solved, I used sybdication of txt file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Have not worked on taxonomy tables but to syndicate to a flat file , in the destination items tab - create the required fields in your case attr ,mat no ,attr name & attribute value ; map these to the source items and create a map of type flat and maintain the item format as variable width , and the output will be as required.
Do let us know if your issue is resolved.
Regards,
Anita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.