Skip to main content
Question

Pull up calculation a1 & N table relationship

  • July 17, 2020
  • 4 replies
  • 2 views

indra.mehta11
Level 4
Forum|alt.badge.img+15

Hi folks

how to define a1 tabLe and N table in pull-up function. I mean which table belongs to a1 and which table belongs to N. I just wanted to know the definition of a1 and N table.

as its creating confusion. As I am new in celonis.

Folks you help will be appreciated.

Best Regards

Inder Mehta

4 replies

  • Level 0
  • 132 replies
  • July 21, 2020

Hi Inder,

there is a pull up function guide available: The longest but ultimate guide for being a Pull-Up-Functions expert

which most probably will answer the question - if not Im happy to help further.

Best regards,

Viana


indra.mehta11
Level 4
Forum|alt.badge.img+15
  • Author
  • Level 4
  • 11 replies
  • July 21, 2020

Hi v.kalversberg,

Thanks a lot for your reply. I have already gone through the above guide. I understood the pull-up Calculation.But I am getting confused in order to understand a1 Table and N table.

Please make my doubt clear on the following.

N Table= Parent Table

a1 Table= Child Table

Am I right on the Above?

Regards

Inder Mehta


  • Level 0
  • 132 replies
  • July 23, 2020

Hi,

yes, the 1 is the child table and n is the parent table:

PU_X ( child_table, parent_table.column [, filter_expression] )

Best regards,

Viana


indra.mehta11
Level 4
Forum|alt.badge.img+15
  • Author
  • Level 4
  • 11 replies
  • July 23, 2020

https://sjc3.discourse-cdn.com/business6/user_avatar/community.celonis.com/v.kalversberg/40/713_2.png v.kalversberg:

Viana

Hi Viana,

Thanks a lot , now i got it.