I want to create a flag column

Sshasnk

Hi I have dataset where I have to create a flag from the fund till the first null cell         

Input:

fund	acount	phone	amount
ABC	123	4578	2356
ABC	123	4578	2356
ABC	123	4578	2356
ABC	123	4578	2356
ABC	123	4578	2356
ABC	123	4578	2356
ABC	123	4578	2356
Check	Total	number	record
	ABC ltd	Ltd

Ouput:

				0
fund	account	phone	amount	1
ABC	123	4578	2356	1
ABC	123	4578	2356	1
ABC	123	4578	2356	1
ABC	123	4578	2356	1
ABC	123	4578	2356	1
ABC	123	4578	2356	1
ABC	123	4578	2356	1
				0
Check	Total	number	record	0
	ABC ltd	Ltd		0

Felipe_Ribeir0

Hi @Sshasnk 

One way of doing this

I want to create a flag column.yxmd