Options

export 2 tables with one dataport to an CSV file

RenkoRenko Member Posts: 8
I have two tables and need information out both the tables.

the export file on this moment looks like this:

1,DB,Dick Beekman //this is table <CourseRegistrationHeader>
2,JR,Johan Rienks

Van Terp Kantoorinrichting,1 //this is table <CourseRegistrationLine>
Anton Geestig Adviezen,1
Koopmans Verzekeringen B.V.,1
Sound&Vision,2
Candoxy Canada Inc.,2

the layout i like to see is like this:

Van Terp Kantoorinrichting,1,DB,Dick Beekman
Anton Geestig Adviezen,1,DB,Dick Beekman
Koopmans Verzekeringen B.V.,1,DB,Dick Beekman
Sound&Vision,2,JR,Johan Rienks
Candoxy Canada Inc.,2,JR,Johan Rienks

table <CourseRegistrationHeader> has the following fields:

Enabled SourceExpr StartPos Width
Yes "No." 1 10
Yes TrainerCode 12 10
Yes "Trainer Name" 23 30

table <CourseRegistrationLine> has the following fields:

Enabled SourceExpr StartPos Width
Yes Name 12 30
Yes No 1 10


where "No." and No must be linked or something.


thanks in advance!

Comments

  • Options
    kinekine Member Posts: 12,562
    Still, you can use Integer table for your dataitem and export just variables. You just needs to fill the variables with the values through C/AL code from both tables and you are done... :-) Without C/AL it is not possible...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    RenkoRenko Member Posts: 8
    Can you give me an example of the C/AL code? I'm a newbie with all of this. I thought it would be possible with just 1 line of code :P
Sign In or Register to comment.